Dataset statistics
| Number of variables | 23 |
|---|---|
| Number of observations | 379068 |
| Missing cells | 32476 |
| Missing cells (%) | 0.4% |
| Duplicate rows | 247 |
| Duplicate rows (%) | 0.1% |
| Total size in memory | 66.5 MiB |
| Average record size in memory | 184.0 B |
Variable types
| Categorical | 11 |
|---|---|
| DateTime | 2 |
| Text | 6 |
| Numeric | 4 |
Billing grp has constant value "LFS" | Constant |
Channel_lfs has constant value "LFS" | Constant |
| Dataset has 247 (0.1%) duplicate rows | Duplicates |
Brand is highly imbalanced (97.0%) | Imbalance |
Channel is highly imbalanced (53.4%) | Imbalance |
Region has 14357 (3.8%) missing values | Missing |
Franchisee store has 18119 (4.8%) missing values | Missing |
Quantity is highly skewed (γ1 = 29.65043719) | Skewed |
Reproduction
| Analysis started | 2024-06-02 16:36:58.680830 |
|---|---|
| Analysis finished | 2024-06-02 16:37:18.707935 |
| Duration | 20.03 seconds |
| Software version | ydata-profiling v4.8.3 |
| Download configuration | config.json |
Year
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| 2022-23 | |
|---|---|
| 2023-24 |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 2653476 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2022-23 |
|---|---|
| 2nd row | 2022-23 |
| 3rd row | 2022-23 |
| 4th row | 2022-23 |
| 5th row | 2022-23 |
Common Values
| Value | Count | Frequency (%) |
| 2022-23 | 196694 | |
| 2023-24 | 182374 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2022-23 | 196694 | |
| 2023-24 | 182374 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 1333898 | |
| 0 | 379068 | 14.3% |
| - | 379068 | 14.3% |
| 3 | 379068 | 14.3% |
| 4 | 182374 | 6.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2653476 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 1333898 | |
| 0 | 379068 | 14.3% |
| - | 379068 | 14.3% |
| 3 | 379068 | 14.3% |
| 4 | 182374 | 6.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2653476 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 1333898 | |
| 0 | 379068 | 14.3% |
| - | 379068 | 14.3% |
| 3 | 379068 | 14.3% |
| 4 | 182374 | 6.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2653476 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 1333898 | |
| 0 | 379068 | 14.3% |
| - | 379068 | 14.3% |
| 3 | 379068 | 14.3% |
| 4 | 182374 | 6.9% |
Month
Date
| Distinct | 51 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| Minimum | 2022-04-01 00:00:00 |
|---|---|
| Maximum | 2024-01-01 00:00:00 |
Histogram with fixed size bins (bins=50)
Month Key
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| Dec | |
|---|---|
| Oct | |
| Jul | |
| Aug | |
| May | |
| Other values (7) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1137204 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Apr |
|---|---|
| 2nd row | Apr |
| 3rd row | Apr |
| 4th row | Apr |
| 5th row | Apr |
Common Values
| Value | Count | Frequency (%) |
| Dec | 41985 | |
| Oct | 36916 | |
| Jul | 34059 | |
| Aug | 33924 | |
| May | 33379 | |
| Apr | 32669 | |
| Jun | 32192 | |
| Jan | 31896 | |
| Nov | 31293 | |
| Sep | 28868 | |
| Other values (2) | 41887 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| dec | 41985 | |
| oct | 36916 | |
| jul | 34059 | |
| aug | 33924 | |
| may | 33379 | |
| apr | 32669 | |
| jun | 32192 | |
| jan | 31896 | |
| nov | 31293 | |
| sep | 28868 | |
| Other values (2) | 41887 |
Most occurring characters
| Value | Count | Frequency (%) |
| u | 100175 | 8.8% |
| e | 98944 | 8.7% |
| J | 98147 | 8.6% |
| a | 79071 | 7.0% |
| c | 78901 | 6.9% |
| A | 66593 | 5.9% |
| n | 64088 | 5.6% |
| p | 61537 | 5.4% |
| M | 47175 | 4.1% |
| r | 46465 | 4.1% |
| Other values (12) | 396108 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1137204 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| u | 100175 | 8.8% |
| e | 98944 | 8.7% |
| J | 98147 | 8.6% |
| a | 79071 | 7.0% |
| c | 78901 | 6.9% |
| A | 66593 | 5.9% |
| n | 64088 | 5.6% |
| p | 61537 | 5.4% |
| M | 47175 | 4.1% |
| r | 46465 | 4.1% |
| Other values (12) | 396108 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1137204 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| u | 100175 | 8.8% |
| e | 98944 | 8.7% |
| J | 98147 | 8.6% |
| a | 79071 | 7.0% |
| c | 78901 | 6.9% |
| A | 66593 | 5.9% |
| n | 64088 | 5.6% |
| p | 61537 | 5.4% |
| M | 47175 | 4.1% |
| r | 46465 | 4.1% |
| Other values (12) | 396108 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1137204 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| u | 100175 | 8.8% |
| e | 98944 | 8.7% |
| J | 98147 | 8.6% |
| a | 79071 | 7.0% |
| c | 78901 | 6.9% |
| A | 66593 | 5.9% |
| n | 64088 | 5.6% |
| p | 61537 | 5.4% |
| M | 47175 | 4.1% |
| r | 46465 | 4.1% |
| Other values (12) | 396108 |
QTR
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| Q3 | |
|---|---|
| Q1 | |
| Q2 | |
| Q4 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 758136 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Q1 |
|---|---|
| 2nd row | Q1 |
| 3rd row | Q1 |
| 4th row | Q1 |
| 5th row | Q1 |
Common Values
| Value | Count | Frequency (%) |
| Q3 | 110194 | |
| Q1 | 98240 | |
| Q2 | 96851 | |
| Q4 | 73783 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| q3 | 110194 | |
| q1 | 98240 | |
| q2 | 96851 | |
| q4 | 73783 |
Most occurring characters
| Value | Count | Frequency (%) |
| Q | 379068 | |
| 3 | 110194 | 14.5% |
| 1 | 98240 | 13.0% |
| 2 | 96851 | 12.8% |
| 4 | 73783 | 9.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 758136 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| Q | 379068 | |
| 3 | 110194 | 14.5% |
| 1 | 98240 | 13.0% |
| 2 | 96851 | 12.8% |
| 4 | 73783 | 9.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 758136 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| Q | 379068 | |
| 3 | 110194 | 14.5% |
| 1 | 98240 | 13.0% |
| 2 | 96851 | 12.8% |
| 4 | 73783 | 9.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 758136 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| Q | 379068 | |
| 3 | 110194 | 14.5% |
| 1 | 98240 | 13.0% |
| 2 | 96851 | 12.8% |
| 4 | 73783 | 9.7% |
Region
Categorical
MISSING
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 14357 |
| Missing (%) | 3.8% |
| Memory size | 2.9 MiB |
| West | |
|---|---|
| South | |
| North | |
| East | |
| NORTH |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 4.5238696 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1649905 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | South |
|---|---|
| 2nd row | South |
| 3rd row | South |
| 4th row | West |
| 5th row | South |
Common Values
| Value | Count | Frequency (%) |
| West | 105498 | |
| South | 90644 | |
| North | 84063 | |
| East | 68152 | |
| NORTH | 16354 | 4.3% |
| (Missing) | 14357 | 3.8% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| west | 105498 | |
| north | 100417 | |
| south | 90644 | |
| east | 68152 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 348357 | |
| o | 174707 | |
| h | 174707 | |
| s | 173650 | |
| W | 105498 | 6.4% |
| e | 105498 | 6.4% |
| N | 100417 | 6.1% |
| S | 90644 | 5.5% |
| u | 90644 | 5.5% |
| r | 84063 | 5.1% |
| Other values (6) | 201720 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1649905 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 348357 | |
| o | 174707 | |
| h | 174707 | |
| s | 173650 | |
| W | 105498 | 6.4% |
| e | 105498 | 6.4% |
| N | 100417 | 6.1% |
| S | 90644 | 5.5% |
| u | 90644 | 5.5% |
| r | 84063 | 5.1% |
| Other values (6) | 201720 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1649905 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 348357 | |
| o | 174707 | |
| h | 174707 | |
| s | 173650 | |
| W | 105498 | 6.4% |
| e | 105498 | 6.4% |
| N | 100417 | 6.1% |
| S | 90644 | 5.5% |
| u | 90644 | 5.5% |
| r | 84063 | 5.1% |
| Other values (6) | 201720 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1649905 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 348357 | |
| o | 174707 | |
| h | 174707 | |
| s | 173650 | |
| W | 105498 | 6.4% |
| e | 105498 | 6.4% |
| N | 100417 | 6.1% |
| S | 90644 | 5.5% |
| u | 90644 | 5.5% |
| r | 84063 | 5.1% |
| Other values (6) | 201720 |
Invoice Date
Date
| Distinct | 700 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| Minimum | 2022-04-01 00:00:00 |
|---|---|
| Maximum | 2024-02-29 00:00:00 |
Histogram with fixed size bins (bins=50)
Material
Text
| Distinct | 191 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 8.5804157 |
| Min length | 7 |
Characters and Unicode
| Total characters | 3252561 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 11 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | NFM03DQ1 |
|---|---|
| 2nd row | NDFM13PD1 |
| 3rd row | NFM05DQ1 |
| 4th row | FW19PC1 |
| 5th row | NEFW05PGC |
| Value | Count | Frequency (%) |
| nffm01pgc | 17026 | 4.5% |
| nfm01dq1 | 16928 | 4.5% |
| nffm01cl2 | 15355 | 4.1% |
| nffw01cl2 | 13397 | 3.5% |
| nefw11pd1 | 12613 | 3.3% |
| nffw02pfc | 12260 | 3.2% |
| nfw01dq1 | 11827 | 3.1% |
| nfm05dq1 | 11229 | 3.0% |
| nfm03dq1 | 10507 | 2.8% |
| nffm14ph1 | 10154 | 2.7% |
| Other values (181) | 247772 |
Most occurring characters
| Value | Count | Frequency (%) |
| F | 600093 | |
| 1 | 448439 | |
| N | 334748 | |
| P | 275296 | |
| 0 | 265721 | |
| M | 201580 | 6.2% |
| W | 160465 | 4.9% |
| D | 154273 | 4.7% |
| C | 147558 | 4.5% |
| 2 | 137695 | 4.2% |
| Other values (15) | 526693 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3252561 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| F | 600093 | |
| 1 | 448439 | |
| N | 334748 | |
| P | 275296 | |
| 0 | 265721 | |
| M | 201580 | 6.2% |
| W | 160465 | 4.9% |
| D | 154273 | 4.7% |
| C | 147558 | 4.5% |
| 2 | 137695 | 4.2% |
| Other values (15) | 526693 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3252561 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| F | 600093 | |
| 1 | 448439 | |
| N | 334748 | |
| P | 275296 | |
| 0 | 265721 | |
| M | 201580 | 6.2% |
| W | 160465 | 4.9% |
| D | 154273 | 4.7% |
| C | 147558 | 4.5% |
| 2 | 137695 | 4.2% |
| Other values (15) | 526693 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3252561 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| F | 600093 | |
| 1 | 448439 | |
| N | 334748 | |
| P | 275296 | |
| 0 | 265721 | |
| M | 201580 | 6.2% |
| W | 160465 | 4.9% |
| D | 154273 | 4.7% |
| C | 147558 | 4.5% |
| 2 | 137695 | 4.2% |
| Other values (15) | 526693 |
Quantity
Real number (ℝ)
SKEWED
| Distinct | 56 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1827957 |
| Minimum | -18 |
|---|---|
| Maximum | 142 |
| Zeros | 194 |
| Zeros (%) | 0.1% |
| Negative | 1127 |
| Negative (%) | 0.3% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | -18 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 142 |
| Range | 160 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.90457777 |
|---|---|
| Coefficient of variation (CV) | 0.76477939 |
| Kurtosis | 2476.1974 |
| Mean | 1.1827957 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 29.650437 |
| Sum | 448360 |
| Variance | 0.81826094 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 331365 | |
| 2 | 35465 | 9.4% |
| 3 | 6681 | 1.8% |
| 4 | 1985 | 0.5% |
| -1 | 1088 | 0.3% |
| 5 | 784 | 0.2% |
| 6 | 434 | 0.1% |
| 7 | 252 | 0.1% |
| 0 | 194 | 0.1% |
| 8 | 160 | < 0.1% |
| Other values (46) | 660 | 0.2% |
| Value | Count | Frequency (%) |
| -18 | 1 | < 0.1% |
| -3 | 5 | < 0.1% |
| -2 | 33 | < 0.1% |
| -1 | 1088 | 0.3% |
| 0 | 194 | 0.1% |
| 1 | 331365 | |
| 2 | 35465 | 9.4% |
| 3 | 6681 | 1.8% |
| 4 | 1985 | 0.5% |
| 5 | 784 | 0.2% |
| Value | Count | Frequency (%) |
| 142 | 1 | |
| 89 | 1 | |
| 75 | 1 | |
| 66 | 1 | |
| 60 | 1 | |
| 58 | 1 | |
| 57 | 1 | |
| 52 | 1 | |
| 49 | 2 | |
| 45 | 2 |
Gender
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| G | |
|---|---|
| L | |
| P | 16987 |
| U | 635 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 379068 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | G |
|---|---|
| 2nd row | G |
| 3rd row | G |
| 4th row | L |
| 5th row | L |
Common Values
| Value | Count | Frequency (%) |
| G | 207062 | |
| L | 154384 | |
| P | 16987 | 4.5% |
| U | 635 | 0.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| g | 207062 | |
| l | 154384 | |
| p | 16987 | 4.5% |
| u | 635 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| G | 207062 | |
| L | 154384 | |
| P | 16987 | 4.5% |
| U | 635 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 379068 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| G | 207062 | |
| L | 154384 | |
| P | 16987 | 4.5% |
| U | 635 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 379068 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| G | 207062 | |
| L | 154384 | |
| P | 16987 | 4.5% |
| U | 635 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 379068 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| G | 207062 | |
| L | 154384 | |
| P | 16987 | 4.5% |
| U | 635 | 0.2% |
Brand
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| TF | |
|---|---|
| FP | 1152 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 758136 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | TF |
|---|---|
| 2nd row | TF |
| 3rd row | TF |
| 4th row | TF |
| 5th row | TF |
Common Values
| Value | Count | Frequency (%) |
| TF | 377916 | |
| FP | 1152 | 0.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| tf | 377916 | |
| fp | 1152 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| F | 379068 | |
| T | 377916 | |
| P | 1152 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 758136 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| F | 379068 | |
| T | 377916 | |
| P | 1152 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 758136 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| F | 379068 | |
| T | 377916 | |
| P | 1152 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 758136 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| F | 379068 | |
| T | 377916 | |
| P | 1152 | 0.2% |
Channel
Categorical
IMBALANCE
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| SS | |
|---|---|
| LS | |
| PT | |
| CT | 11909 |
| RRL | 1007 |
| Other values (4) | 1059 |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.0026565 |
| Min length | 2 |
Characters and Unicode
| Total characters | 759143 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CN |
|---|---|
| 2nd row | CN |
| 3rd row | CN |
| 4th row | CN |
| 5th row | CN |
Common Values
| Value | Count | Frequency (%) |
| SS | 190091 | |
| LS | 152260 | |
| PT | 22742 | 6.0% |
| CT | 11909 | 3.1% |
| RRL | 1007 | 0.3% |
| LL | 655 | 0.2% |
| CN | 263 | 0.1% |
| ss | 72 | < 0.1% |
| AZ | 69 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| ss | 190163 | |
| ls | 152260 | |
| pt | 22742 | 6.0% |
| ct | 11909 | 3.1% |
| rrl | 1007 | 0.3% |
| ll | 655 | 0.2% |
| cn | 263 | 0.1% |
| az | 69 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 532442 | |
| L | 154577 | 20.4% |
| T | 34651 | 4.6% |
| P | 22742 | 3.0% |
| C | 12172 | 1.6% |
| R | 2014 | 0.3% |
| N | 263 | < 0.1% |
| s | 144 | < 0.1% |
| A | 69 | < 0.1% |
| Z | 69 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 759143 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| S | 532442 | |
| L | 154577 | 20.4% |
| T | 34651 | 4.6% |
| P | 22742 | 3.0% |
| C | 12172 | 1.6% |
| R | 2014 | 0.3% |
| N | 263 | < 0.1% |
| s | 144 | < 0.1% |
| A | 69 | < 0.1% |
| Z | 69 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 759143 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| S | 532442 | |
| L | 154577 | 20.4% |
| T | 34651 | 4.6% |
| P | 22742 | 3.0% |
| C | 12172 | 1.6% |
| R | 2014 | 0.3% |
| N | 263 | < 0.1% |
| s | 144 | < 0.1% |
| A | 69 | < 0.1% |
| Z | 69 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 759143 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| S | 532442 | |
| L | 154577 | 20.4% |
| T | 34651 | 4.6% |
| P | 22742 | 3.0% |
| C | 12172 | 1.6% |
| R | 2014 | 0.3% |
| N | 263 | < 0.1% |
| s | 144 | < 0.1% |
| A | 69 | < 0.1% |
| Z | 69 | < 0.1% |
Franchisee store
Text
MISSING
| Distinct | 392 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 18119 |
| Missing (%) | 4.8% |
| Memory size | 2.9 MiB |
Length
| Max length | 7 |
|---|---|
| Median length | 5 |
| Mean length | 5.0946837 |
| Min length | 5 |
Characters and Unicode
| Total characters | 1838921 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | CN1200 |
|---|---|
| 2nd row | CN1201 |
| 3rd row | CN1201 |
| 4th row | CN1206 |
| 5th row | CN1212 |
| Value | Count | Frequency (%) |
| ss222 | 8146 | 2.3% |
| ss223 | 6940 | 1.9% |
| ls751 | 6759 | 1.9% |
| ls760 | 6096 | 1.7% |
| ss283 | 4787 | 1.3% |
| ss255 | 4754 | 1.3% |
| ls758 | 4160 | 1.2% |
| ss209 | 4114 | 1.1% |
| ls741 | 4018 | 1.1% |
| ss225 | 3885 | 1.1% |
| Other values (382) | 307290 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 507600 | |
| 2 | 236294 | |
| 7 | 189211 | 10.3% |
| L | 146372 | 8.0% |
| 3 | 140869 | 7.7% |
| 1 | 127982 | 7.0% |
| 0 | 107281 | 5.8% |
| 8 | 67568 | 3.7% |
| 5 | 66767 | 3.6% |
| 4 | 66621 | 3.6% |
| Other values (11) | 182356 | 9.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1838921 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| S | 507600 | |
| 2 | 236294 | |
| 7 | 189211 | 10.3% |
| L | 146372 | 8.0% |
| 3 | 140869 | 7.7% |
| 1 | 127982 | 7.0% |
| 0 | 107281 | 5.8% |
| 8 | 67568 | 3.7% |
| 5 | 66767 | 3.6% |
| 4 | 66621 | 3.6% |
| Other values (11) | 182356 | 9.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1838921 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| S | 507600 | |
| 2 | 236294 | |
| 7 | 189211 | 10.3% |
| L | 146372 | 8.0% |
| 3 | 140869 | 7.7% |
| 1 | 127982 | 7.0% |
| 0 | 107281 | 5.8% |
| 8 | 67568 | 3.7% |
| 5 | 66767 | 3.6% |
| 4 | 66621 | 3.6% |
| Other values (11) | 182356 | 9.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1838921 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| S | 507600 | |
| 2 | 236294 | |
| 7 | 189211 | 10.3% |
| L | 146372 | 8.0% |
| 3 | 140869 | 7.7% |
| 1 | 127982 | 7.0% |
| 0 | 107281 | 5.8% |
| 8 | 67568 | 3.7% |
| 5 | 66767 | 3.6% |
| 4 | 66621 | 3.6% |
| Other values (11) | 182356 | 9.9% |
| Distinct | 392 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
Length
| Max length | 7 |
|---|---|
| Median length | 5 |
| Mean length | 5.095041 |
| Min length | 5 |
Characters and Unicode
| Total characters | 1931367 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | CN1200 |
|---|---|
| 2nd row | CN1201 |
| 3rd row | CN1201 |
| 4th row | CN1206 |
| 5th row | CN1212 |
| Value | Count | Frequency (%) |
| ss222 | 8550 | 2.3% |
| ss223 | 7273 | 1.9% |
| ls751 | 7103 | 1.9% |
| ls760 | 6376 | 1.7% |
| ss283 | 5021 | 1.3% |
| ss255 | 4986 | 1.3% |
| ls758 | 4359 | 1.1% |
| ss209 | 4327 | 1.1% |
| ls741 | 4245 | 1.1% |
| ss225 | 4071 | 1.1% |
| Other values (382) | 322757 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 532587 | |
| 2 | 247595 | |
| 7 | 198599 | 10.3% |
| L | 153921 | 8.0% |
| 3 | 148253 | 7.7% |
| 1 | 134388 | 7.0% |
| 0 | 113301 | 5.9% |
| 8 | 71214 | 3.7% |
| 5 | 69945 | 3.6% |
| 4 | 69736 | 3.6% |
| Other values (11) | 191828 | 9.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1931367 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| S | 532587 | |
| 2 | 247595 | |
| 7 | 198599 | 10.3% |
| L | 153921 | 8.0% |
| 3 | 148253 | 7.7% |
| 1 | 134388 | 7.0% |
| 0 | 113301 | 5.9% |
| 8 | 71214 | 3.7% |
| 5 | 69945 | 3.6% |
| 4 | 69736 | 3.6% |
| Other values (11) | 191828 | 9.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1931367 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| S | 532587 | |
| 2 | 247595 | |
| 7 | 198599 | 10.3% |
| L | 153921 | 8.0% |
| 3 | 148253 | 7.7% |
| 1 | 134388 | 7.0% |
| 0 | 113301 | 5.9% |
| 8 | 71214 | 3.7% |
| 5 | 69945 | 3.6% |
| 4 | 69736 | 3.6% |
| Other values (11) | 191828 | 9.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1931367 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| S | 532587 | |
| 2 | 247595 | |
| 7 | 198599 | 10.3% |
| L | 153921 | 8.0% |
| 3 | 148253 | 7.7% |
| 1 | 134388 | 7.0% |
| 0 | 113301 | 5.9% |
| 8 | 71214 | 3.7% |
| 5 | 69945 | 3.6% |
| 4 | 69736 | 3.6% |
| Other values (11) | 191828 | 9.9% |
| Distinct | 575 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
Length
| Max length | 42 |
|---|---|
| Median length | 33 |
| Mean length | 20.672948 |
| Min length | 7 |
Characters and Unicode
| Total characters | 7836453 |
|---|---|
| Distinct characters | 70 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 11 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | CT-BENGALURU-RESIDENCYROAD |
|---|---|
| 2nd row | CT-HYDERABAD-G.S.CENTERPOINT |
| 3rd row | CT-HYDERABAD-G.S.CENTERPOINT |
| 4th row | CT-MUMBAI-GOREGAON-OBEROIMALL |
| 5th row | CT-BENGALURU-J.P.NAGAR |
| Value | Count | Frequency (%) |
| 40027 | 5.3% | |
| city | 22369 | 3.0% |
| mall | 18239 | 2.4% |
| kolkata | 17513 | 2.3% |
| ls | 12014 | 1.6% |
| market | 10677 | 1.4% |
| phoenix | 9901 | 1.3% |
| pune | 7061 | 0.9% |
| center | 6200 | 0.8% |
| lake | 5833 | 0.8% |
| Other values (871) | 599672 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 629576 | 8.0% |
| S | 566600 | 7.2% |
| A | 491640 | 6.3% |
| L | 475409 | 6.1% |
| 368424 | 4.7% | |
| a | 359894 | 4.6% |
| T | 241821 | 3.1% |
| R | 222738 | 2.8% |
| N | 191587 | 2.4% |
| O | 190396 | 2.4% |
| Other values (60) | 4098368 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7836453 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 629576 | 8.0% |
| S | 566600 | 7.2% |
| A | 491640 | 6.3% |
| L | 475409 | 6.1% |
| 368424 | 4.7% | |
| a | 359894 | 4.6% |
| T | 241821 | 3.1% |
| R | 222738 | 2.8% |
| N | 191587 | 2.4% |
| O | 190396 | 2.4% |
| Other values (60) | 4098368 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7836453 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 629576 | 8.0% |
| S | 566600 | 7.2% |
| A | 491640 | 6.3% |
| L | 475409 | 6.1% |
| 368424 | 4.7% | |
| a | 359894 | 4.6% |
| T | 241821 | 3.1% |
| R | 222738 | 2.8% |
| N | 191587 | 2.4% |
| O | 190396 | 2.4% |
| Other values (60) | 4098368 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7836453 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 629576 | 8.0% |
| S | 566600 | 7.2% |
| A | 491640 | 6.3% |
| L | 475409 | 6.1% |
| 368424 | 4.7% | |
| a | 359894 | 4.6% |
| T | 241821 | 3.1% |
| R | 222738 | 2.8% |
| N | 191587 | 2.4% |
| O | 190396 | 2.4% |
| Other values (60) | 4098368 |
MRP
Real number (ℝ)
| Distinct | 37 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1679.6416 |
| Minimum | 395 |
|---|---|
| Maximum | 4995 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | 395 |
|---|---|
| 5-th percentile | 499 |
| Q1 | 645 |
| median | 1895 |
| Q3 | 2595 |
| 95-th percentile | 3095 |
| Maximum | 4995 |
| Range | 4600 |
| Interquartile range (IQR) | 1950 |
Descriptive statistics
| Standard deviation | 1007.175 |
|---|---|
| Coefficient of variation (CV) | 0.59963687 |
| Kurtosis | -0.62586443 |
| Mean | 1679.6416 |
| Median Absolute Deviation (MAD) | 800 |
| Skewness | 0.36956364 |
| Sum | 6.3669839 × 108 |
| Variance | 1014401.6 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=37)
| Value | Count | Frequency (%) |
| 499 | 82974 | |
| 2595 | 52280 | |
| 645 | 47030 | |
| 1995 | 46983 | |
| 1595 | 30835 | 8.1% |
| 1895 | 22192 | 5.9% |
| 2695 | 18444 | 4.9% |
| 3995 | 12883 | 3.4% |
| 2295 | 8996 | 2.4% |
| 2995 | 8841 | 2.3% |
| Other values (27) | 47610 |
| Value | Count | Frequency (%) |
| 395 | 515 | 0.1% |
| 399 | 193 | 0.1% |
| 499 | 82974 | |
| 545 | 339 | 0.1% |
| 595 | 5005 | 1.3% |
| 645 | 47030 | |
| 845 | 3273 | 0.9% |
| 895 | 522 | 0.1% |
| 995 | 2661 | 0.7% |
| 1195 | 18 | < 0.1% |
| Value | Count | Frequency (%) |
| 4995 | 315 | 0.1% |
| 4795 | 784 | 0.2% |
| 4590 | 1000 | 0.3% |
| 4190 | 452 | 0.1% |
| 3995 | 12883 | |
| 3095 | 7139 | 1.9% |
| 2995 | 8841 | |
| 2895 | 1270 | 0.3% |
| 2795 | 5734 | 1.5% |
| 2695 | 18444 |
Gross UCP
Real number (ℝ)
| Distinct | 332 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1970.7081 |
| Minimum | -28710 |
|---|---|
| Maximum | 177555 |
| Zeros | 194 |
| Zeros (%) | 0.1% |
| Negative | 1127 |
| Negative (%) | 0.3% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | -28710 |
|---|---|
| 5-th percentile | 499 |
| Q1 | 645 |
| median | 1895 |
| Q3 | 2595 |
| 95-th percentile | 4590 |
| Maximum | 177555 |
| Range | 206265 |
| Interquartile range (IQR) | 1950 |
Descriptive statistics
| Standard deviation | 1910.1406 |
|---|---|
| Coefficient of variation (CV) | 0.96926612 |
| Kurtosis | 626.27308 |
| Mean | 1970.7081 |
| Median Absolute Deviation (MAD) | 900 |
| Skewness | 13.478237 |
| Sum | 7.4703237 × 108 |
| Variance | 3648637 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 499 | 71971 | |
| 2595 | 45872 | |
| 645 | 41853 | |
| 1995 | 40929 | |
| 1595 | 23583 | 6.2% |
| 1895 | 18954 | 5.0% |
| 2695 | 16647 | 4.4% |
| 3995 | 11704 | 3.1% |
| 998 | 8825 | 2.3% |
| 2295 | 8300 | 2.2% |
| Other values (322) | 90430 |
| Value | Count | Frequency (%) |
| -28710 | 1 | |
| -11985 | 1 | |
| -7990 | 1 | |
| -7785 | 1 | |
| -5990 | 1 | |
| -5590 | 1 | |
| -5390 | 2 | |
| -5190 | 1 | |
| -4995 | 1 | |
| -4990 | 2 |
| Value | Count | Frequency (%) |
| 177555 | 1 | |
| 142125 | 1 | |
| 134775 | 1 | |
| 125790 | 1 | |
| 119800 | 1 | |
| 105270 | 1 | |
| 95700 | 1 | |
| 92510 | 1 | |
| 91590 | 1 | |
| 90915 | 1 |
Net UCP
Real number (ℝ)
| Distinct | 9883 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1776.898 |
| Minimum | -17982 |
|---|---|
| Maximum | 127912.5 |
| Zeros | 1332 |
| Zeros (%) | 0.4% |
| Negative | 1133 |
| Negative (%) | 0.3% |
| Memory size | 2.9 MiB |
Quantile statistics
| Minimum | -17982 |
|---|---|
| 5-th percentile | 499 |
| Q1 | 645 |
| median | 1695.75 |
| Q3 | 2395 |
| 95-th percentile | 3995 |
| Maximum | 127912.5 |
| Range | 145894.5 |
| Interquartile range (IQR) | 1750 |
Descriptive statistics
| Standard deviation | 1528.2469 |
|---|---|
| Coefficient of variation (CV) | 0.86006454 |
| Kurtosis | 511.42824 |
| Mean | 1776.898 |
| Median Absolute Deviation (MAD) | 899.25 |
| Skewness | 10.408456 |
| Sum | 6.7356516 × 108 |
| Variance | 2335538.7 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 499 | 57465 | 15.2% |
| 645 | 35530 | 9.4% |
| 2595 | 23745 | 6.3% |
| 1995 | 22154 | 5.8% |
| 1595 | 12801 | 3.4% |
| 1895 | 11416 | 3.0% |
| 1795.5 | 9450 | 2.5% |
| 999 | 8656 | 2.3% |
| 2695 | 8391 | 2.2% |
| 3995 | 7567 | 2.0% |
| Other values (9873) | 181893 |
| Value | Count | Frequency (%) |
| -17982 | 1 | < 0.1% |
| -11985 | 1 | < 0.1% |
| -7990 | 1 | < 0.1% |
| -6785 | 1 | < 0.1% |
| -6380 | 1 | < 0.1% |
| -5190 | 1 | < 0.1% |
| -5091.5 | 1 | < 0.1% |
| -4795 | 1 | < 0.1% |
| -4590 | 3 | |
| -4495 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 127912.5 | 1 | |
| 125705.09 | 1 | |
| 107820 | 1 | |
| 106921.5 | 1 | |
| 99800 | 1 | |
| 78045 | 1 | |
| 73381 | 1 | |
| 65934 | 1 | |
| 59940 | 1 | |
| 57942 | 1 |
| Distinct | 161 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
Length
| Max length | 20 |
|---|---|
| Median length | 17 |
| Mean length | 6.9078714 |
| Min length | 3 |
Characters and Unicode
| Total characters | 2618553 |
|---|---|
| Distinct characters | 54 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Bangalore |
|---|---|
| 2nd row | Hyderabad |
| 3rd row | Hyderabad |
| 4th row | Mumbai |
| 5th row | Bangalore |
| Value | Count | Frequency (%) |
| mumbai | 46993 | 12.4% |
| kolkata | 44677 | 11.8% |
| bangalore | 40943 | 10.8% |
| delhi | 25910 | 6.8% |
| pune | 24810 | 6.5% |
| hyderabad | 19183 | 5.0% |
| noida | 16699 | 4.4% |
| chennai | 12188 | 3.2% |
| gurgaon | 9426 | 2.5% |
| lucknow | 8666 | 2.3% |
| Other values (106) | 130715 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 466338 | |
| i | 158281 | 6.0% |
| o | 156486 | 6.0% |
| e | 154444 | 5.9% |
| n | 150344 | 5.7% |
| r | 148286 | 5.7% |
| u | 144671 | 5.5% |
| l | 130077 | 5.0% |
| d | 97983 | 3.7% |
| h | 92844 | 3.5% |
| Other values (44) | 918799 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 2618553 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 466338 | |
| i | 158281 | 6.0% |
| o | 156486 | 6.0% |
| e | 154444 | 5.9% |
| n | 150344 | 5.7% |
| r | 148286 | 5.7% |
| u | 144671 | 5.5% |
| l | 130077 | 5.0% |
| d | 97983 | 3.7% |
| h | 92844 | 3.5% |
| Other values (44) | 918799 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 2618553 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 466338 | |
| i | 158281 | 6.0% |
| o | 156486 | 6.0% |
| e | 154444 | 5.9% |
| n | 150344 | 5.7% |
| r | 148286 | 5.7% |
| u | 144671 | 5.5% |
| l | 130077 | 5.0% |
| d | 97983 | 3.7% |
| h | 92844 | 3.5% |
| Other values (44) | 918799 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 2618553 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 466338 | |
| i | 158281 | 6.0% |
| o | 156486 | 6.0% |
| e | 154444 | 5.9% |
| n | 150344 | 5.7% |
| r | 148286 | 5.7% |
| u | 144671 | 5.5% |
| l | 130077 | 5.0% |
| d | 97983 | 3.7% |
| h | 92844 | 3.5% |
| Other values (44) | 918799 |
ShiptopartyStateCode
Categorical
| Distinct | 40 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| MAHARASTRA | |
|---|---|
| WESTBENGAL | |
| DELHI | |
| KARNATAKA | |
| UTTARPRADESH | |
| Other values (35) |
Length
| Max length | 20 |
|---|---|
| Median length | 17 |
| Mean length | 10.148902 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3847124 |
|---|---|
| Distinct characters | 39 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | KARNATAKA |
|---|---|
| 2nd row | TELANGANA |
| 3rd row | TELANGANA |
| 4th row | MAHARASTRA |
| 5th row | KARNATAKA |
Common Values
| Value | Count | Frequency (%) |
| MAHARASTRA | 83901 | |
| WESTBENGAL | 39421 | |
| DELHI | 28428 | 7.5% |
| KARNATAKA | 25078 | 6.6% |
| UTTARPRADESH | 23876 | 6.3% |
| KARNATAKA | 22044 | 5.8% |
| WEST BENGAL | 19783 | 5.2% |
| GUJARAT | 15779 | 4.2% |
| HARYANA | 14430 | 3.8% |
| TAMILNADU | 11498 | 3.0% |
| Other values (30) | 94830 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| maharastra | 83901 | |
| karnataka | 47122 | |
| westbengal | 39421 | 9.1% |
| pradesh | 28763 | 6.6% |
| delhi | 28428 | 6.5% |
| uttarpradesh | 23876 | 5.5% |
| west | 19783 | 4.6% |
| bengal | 19783 | 4.6% |
| telangana | 19211 | 4.4% |
| gujarat | 15779 | 3.6% |
| Other values (26) | 108183 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 916792 | |
| R | 367412 | |
| 362270 | 9.4% | |
| T | 327349 | 8.5% |
| H | 225007 | 5.8% |
| S | 221506 | 5.8% |
| E | 215195 | 5.6% |
| N | 182939 | 4.8% |
| D | 123128 | 3.2% |
| L | 119013 | 3.1% |
| Other values (29) | 786513 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3847124 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 916792 | |
| R | 367412 | |
| 362270 | 9.4% | |
| T | 327349 | 8.5% |
| H | 225007 | 5.8% |
| S | 221506 | 5.8% |
| E | 215195 | 5.6% |
| N | 182939 | 4.8% |
| D | 123128 | 3.2% |
| L | 119013 | 3.1% |
| Other values (29) | 786513 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3847124 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 916792 | |
| R | 367412 | |
| 362270 | 9.4% | |
| T | 327349 | 8.5% |
| H | 225007 | 5.8% |
| S | 221506 | 5.8% |
| E | 215195 | 5.6% |
| N | 182939 | 4.8% |
| D | 123128 | 3.2% |
| L | 119013 | 3.1% |
| Other values (29) | 786513 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3847124 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 916792 | |
| R | 367412 | |
| 362270 | 9.4% | |
| T | 327349 | 8.5% |
| H | 225007 | 5.8% |
| S | 221506 | 5.8% |
| E | 215195 | 5.6% |
| N | 182939 | 4.8% |
| D | 123128 | 3.2% |
| L | 119013 | 3.1% |
| Other values (29) | 786513 |
Billing grp
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| LFS |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1137204 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LFS |
|---|---|
| 2nd row | LFS |
| 3rd row | LFS |
| 4th row | LFS |
| 5th row | LFS |
Common Values
| Value | Count | Frequency (%) |
| LFS | 379068 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| lfs | 379068 |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 379068 | |
| F | 379068 | |
| S | 379068 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1137204 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| L | 379068 | |
| F | 379068 | |
| S | 379068 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1137204 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| L | 379068 | |
| F | 379068 | |
| S | 379068 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1137204 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| L | 379068 | |
| F | 379068 | |
| S | 379068 |
Channel_lfs
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| LFS |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1137204 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LFS |
|---|---|
| 2nd row | LFS |
| 3rd row | LFS |
| 4th row | LFS |
| 5th row | LFS |
Common Values
| Value | Count | Frequency (%) |
| LFS | 379068 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| lfs | 379068 |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 379068 | |
| F | 379068 | |
| S | 379068 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1137204 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| L | 379068 | |
| F | 379068 | |
| S | 379068 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1137204 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| L | 379068 | |
| F | 379068 | |
| S | 379068 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1137204 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| L | 379068 | |
| F | 379068 | |
| S | 379068 |
Varient_Name
Text
| Distinct | 143 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
Length
| Max length | 52 |
|---|---|
| Median length | 35 |
| Mean length | 16.715993 |
| Min length | 8 |
Characters and Unicode
| Total characters | 6336498 |
|---|---|
| Distinct characters | 67 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 6 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 3. 150 M Amalfi Men deo |
|---|---|
| 2nd row | 3. 20 M Verge |
| 3rd row | 8. Deo M C. Road 150 ml |
| 4th row | 3. Tales W Ibiza 100 ml |
| 5th row | 7. 100 W Pristine |
| Value | Count | Frequency (%) |
| m | 206967 | 11.9% |
| w | 156728 | 9.0% |
| deo | 120395 | 6.9% |
| ml | 117070 | 6.7% |
| 100 | 111533 | 6.4% |
| 150 | 83167 | 4.8% |
| raw | 64736 | 3.7% |
| 20 | 57621 | 3.3% |
| celeste | 56602 | 3.2% |
| 1 | 44321 | 2.5% |
| Other values (115) | 723276 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1363725 | ||
| e | 580247 | 9.2% |
| 0 | 440882 | 7.0% |
| l | 256745 | 4.1% |
| o | 253746 | 4.0% |
| M | 248651 | 3.9% |
| 1 | 247972 | 3.9% |
| . | 218260 | 3.4% |
| a | 178549 | 2.8% |
| 5 | 167853 | 2.6% |
| Other values (57) | 2379868 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6336498 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1363725 | ||
| e | 580247 | 9.2% |
| 0 | 440882 | 7.0% |
| l | 256745 | 4.1% |
| o | 253746 | 4.0% |
| M | 248651 | 3.9% |
| 1 | 247972 | 3.9% |
| . | 218260 | 3.4% |
| a | 178549 | 2.8% |
| 5 | 167853 | 2.6% |
| Other values (57) | 2379868 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6336498 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1363725 | ||
| e | 580247 | 9.2% |
| 0 | 440882 | 7.0% |
| l | 256745 | 4.1% |
| o | 253746 | 4.0% |
| M | 248651 | 3.9% |
| 1 | 247972 | 3.9% |
| . | 218260 | 3.4% |
| a | 178549 | 2.8% |
| 5 | 167853 | 2.6% |
| Other values (57) | 2379868 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6336498 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1363725 | ||
| e | 580247 | 9.2% |
| 0 | 440882 | 7.0% |
| l | 256745 | 4.1% |
| o | 253746 | 4.0% |
| M | 248651 | 3.9% |
| 1 | 247972 | 3.9% |
| . | 218260 | 3.4% |
| a | 178549 | 2.8% |
| 5 | 167853 | 2.6% |
| Other values (57) | 2379868 |
Collection
Categorical
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.9 MiB |
| Gift Pack | |
|---|---|
| Classic 100 ml | |
| Premium Deo | |
| Classic 20 ml | |
| Aqua | |
| Other values (14) |
Length
| Max length | 15 |
|---|---|
| Median length | 13 |
| Mean length | 10.990065 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4165982 |
|---|---|
| Distinct characters | 38 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Premium Deo |
|---|---|
| 2nd row | Classic 20 ml |
| 3rd row | Escapade Deo |
| 4th row | Tales 100ml |
| 5th row | Classic 100 ml |
Common Values
| Value | Count | Frequency (%) |
| Gift Pack | 62820 | |
| Classic 100 ml | 61611 | |
| Premium Deo | 58719 | |
| Classic 20 ml | 52374 | |
| Aqua | 29753 | |
| Classic 50 ml | 26505 | |
| Escapade Deo | 24448 | 6.4% |
| Escapade | 19996 | 5.3% |
| Nox 100 ml | 12883 | 3.4% |
| Tales 100ml | 8704 | 2.3% |
| Other values (9) | 21255 | 5.6% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| ml | 158620 | |
| classic | 141760 | |
| deo | 89551 | |
| 100 | 74494 | |
| pack | 69204 | |
| gift | 62820 | 7.1% |
| premium | 58719 | 6.7% |
| 20 | 57621 | 6.6% |
| escapade | 44444 | 5.1% |
| aqua | 29753 | 3.4% |
| Other values (13) | 92344 |
Most occurring characters
| Value | Count | Frequency (%) |
| 500262 | ||
| a | 351698 | 8.4% |
| s | 337877 | 8.1% |
| l | 332585 | 8.0% |
| m | 291907 | 7.0% |
| 0 | 264800 | 6.4% |
| i | 263335 | 6.3% |
| c | 256602 | 6.2% |
| e | 209078 | 5.0% |
| C | 141760 | 3.4% |
| Other values (28) | 1216078 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4165982 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 500262 | ||
| a | 351698 | 8.4% |
| s | 337877 | 8.1% |
| l | 332585 | 8.0% |
| m | 291907 | 7.0% |
| 0 | 264800 | 6.4% |
| i | 263335 | 6.3% |
| c | 256602 | 6.2% |
| e | 209078 | 5.0% |
| C | 141760 | 3.4% |
| Other values (28) | 1216078 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4165982 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 500262 | ||
| a | 351698 | 8.4% |
| s | 337877 | 8.1% |
| l | 332585 | 8.0% |
| m | 291907 | 7.0% |
| 0 | 264800 | 6.4% |
| i | 263335 | 6.3% |
| c | 256602 | 6.2% |
| e | 209078 | 5.0% |
| C | 141760 | 3.4% |
| Other values (28) | 1216078 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4165982 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 500262 | ||
| a | 351698 | 8.4% |
| s | 337877 | 8.1% |
| l | 332585 | 8.0% |
| m | 291907 | 7.0% |
| 0 | 264800 | 6.4% |
| i | 263335 | 6.3% |
| c | 256602 | 6.2% |
| e | 209078 | 5.0% |
| C | 141760 | 3.4% |
| Other values (28) | 1216078 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| Year | Month | Month Key | QTR | Region | Invoice Date | Material | Quantity | Gender | Brand | Channel | Franchisee store | Bill to Party code | Bill to Party Name | MRP | Gross UCP | Net UCP | Bill to Party City | ShiptopartyStateCode | Billing grp | Channel_lfs | Varient_Name | Collection | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2022-23 | 2022-04-01 | Apr | Q1 | South | 2022-04-01 00:00:00 | NFM03DQ1 | 4.0 | G | TF | CN | CN1200 | CN1200 | CT-BENGALURU-RESIDENCYROAD | 499 | 1996.0 | 1996.0 | Bangalore | KARNATAKA | LFS | LFS | 3. 150 M Amalfi Men deo | Premium Deo |
| 1 | 2022-23 | 2022-04-01 | Apr | Q1 | South | 2022-04-01 00:00:00 | NDFM13PD1 | 1.0 | G | TF | CN | CN1201 | CN1201 | CT-HYDERABAD-G.S.CENTERPOINT | 595 | 595.0 | 595.0 | Hyderabad | TELANGANA | LFS | LFS | 3. 20 M Verge | Classic 20 ml |
| 2 | 2022-23 | 2022-04-01 | Apr | Q1 | South | 2022-04-01 00:00:00 | NFM05DQ1 | 1.0 | G | TF | CN | CN1201 | CN1201 | CT-HYDERABAD-G.S.CENTERPOINT | 499 | 499.0 | 499.0 | Hyderabad | TELANGANA | LFS | LFS | 8. Deo M C. Road 150 ml | Escapade Deo |
| 3 | 2022-23 | 2022-04-01 | Apr | Q1 | West | 2022-04-01 00:00:00 | FW19PC1 | 1.0 | L | TF | CN | CN1206 | CN1206 | CT-MUMBAI-GOREGAON-OBEROIMALL | 1595 | 1595.0 | 1595.0 | Mumbai | MAHARASTRA | LFS | LFS | 3. Tales W Ibiza 100 ml | Tales 100ml |
| 4 | 2022-23 | 2022-04-01 | Apr | Q1 | South | 2022-04-01 00:00:00 | NEFW05PGC | 1.0 | L | TF | CN | CN1212 | CN1212 | CT-BENGALURU-J.P.NAGAR | 2295 | 2295.0 | 2295.0 | Bangalore | KARNATAKA | LFS | LFS | 7. 100 W Pristine | Classic 100 ml |
| 5 | 2022-23 | 2022-04-01 | Apr | Q1 | South | 2022-04-01 00:00:00 | NFM01DQ1 | 1.0 | G | TF | CN | CN1212 | CN1212 | CT-BENGALURU-J.P.NAGAR | 499 | 499.0 | 499.0 | Bangalore | KARNATAKA | LFS | LFS | 1. 150 M Raw Deo | Premium Deo |
| 6 | 2022-23 | 2022-04-01 | Apr | Q1 | South | 2022-04-01 00:00:00 | NFFM05PG2 | 1.0 | G | TF | CN | CN1212 | CN1212 | CT-BENGALURU-J.P.NAGAR | 1995 | 1995.0 | 1995.0 | Bangalore | KARNATAKA | LFS | LFS | 2. Mini 25 ml M (R,V) | Gift Pack |
| 7 | 2022-23 | 2022-04-01 | Apr | Q1 | West | 2022-04-01 00:00:00 | NFM02DQ1 | 1.0 | G | TF | CN | CN1231 | CN1231 | CT-PIMPRI-CITYCENTREMALL | 499 | 499.0 | 499.0 | Pune | MAHARASTRA | LFS | LFS | 2. 150 M Steele Deo | Premium Deo |
| 8 | 2022-23 | 2022-04-01 | Apr | Q1 | West | 2022-04-01 00:00:00 | NFW02DQ1 | 1.0 | L | TF | CN | CN1231 | CN1231 | CT-PIMPRI-CITYCENTREMALL | 499 | 499.0 | 499.0 | Pune | MAHARASTRA | LFS | LFS | 5. 150 W Nude Deo | Premium Deo |
| 9 | 2022-23 | 2022-04-01 | Apr | Q1 | North | 2022-04-01 00:00:00 | NEFM01PGC | 1.0 | G | TF | CN | CN1239 | CN1239 | CT-NEWDELHI-WORLDMARK | 2295 | 2295.0 | 1951.0 | Delhi | DELHI | LFS | LFS | 1. 100 M Raw | Classic 100 ml |
| Year | Month | Month Key | QTR | Region | Invoice Date | Material | Quantity | Gender | Brand | Channel | Franchisee store | Bill to Party code | Bill to Party Name | MRP | Gross UCP | Net UCP | Bill to Party City | ShiptopartyStateCode | Billing grp | Channel_lfs | Varient_Name | Collection | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 379058 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-05 00:00:00 | FW22PC1 | 1.0 | L | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 3095 | 3095.0 | 3095.00 | Ranchi | JHARKHAND | LFS | LFS | Noura W Iris 100 ml | Noura W 100ml |
| 379059 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-17 00:00:00 | FW22PC1 | 1.0 | L | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 3095 | 3095.0 | 3095.00 | Ranchi | JHARKHAND | LFS | LFS | Noura W Iris 100 ml | Noura W 100ml |
| 379060 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-08 00:00:00 | NFFW14PK1 | 1.0 | L | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 2795 | 2795.0 | 2795.00 | Ranchi | JHARKHAND | LFS | LFS | Aqua W 90 ml | Aqua |
| 379061 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-05 00:00:00 | NFFW03PFL | 1.0 | L | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 1895 | 1895.0 | 1895.00 | Ranchi | JHARKHAND | LFS | LFS | 50 W Nude | Classic 50 ml |
| 379062 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-15 00:00:00 | NFFW01CL2 | 1.0 | G | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 1995 | 1995.0 | 1995.00 | Ranchi | JHARKHAND | LFS | LFS | Coffret Deo W Celeste | Gift Pack |
| 379063 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-12 00:00:00 | NFFW01CL2 | 1.0 | G | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 1995 | 1995.0 | 1995.00 | Ranchi | JHARKHAND | LFS | LFS | Coffret Deo W Celeste | Gift Pack |
| 379064 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-05 00:00:00 | NFFM01PGL | 1.0 | G | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 1895 | 1895.0 | 1895.00 | Ranchi | JHARKHAND | LFS | LFS | 50 M Raw | Classic 50 ml |
| 379065 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-11 00:00:00 | NFFW03PFC | 1.0 | L | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 2595 | 2595.0 | 2122.32 | Ranchi | JHARKHAND | LFS | LFS | 100 W Nude | Classic 100 ml |
| 379066 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-21 00:00:00 | NGFM08PC1 | 1.0 | G | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 2695 | 2695.0 | 2695.00 | Ranchi | JHARKHAND | LFS | LFS | 100 M CRoad | Escapade |
| 379067 | 2023-24 | 2023-02-01 | Feb | Q4 | East | 2024-02-21 00:00:00 | NFFP01PG2 | 1.0 | P | TF | SS | SS292 | SS292 | 312-SSL-RANCHI | 1995 | 1995.0 | 1995.00 | Ranchi | JHARKHAND | LFS | LFS | His & Her Mini 25 ml (V,S) | Gift Pack |
Most frequently occurring
| Year | Month | Month Key | QTR | Region | Invoice Date | Material | Quantity | Gender | Brand | Channel | Franchisee store | Bill to Party code | Bill to Party Name | MRP | Gross UCP | Net UCP | Bill to Party City | ShiptopartyStateCode | Billing grp | Channel_lfs | Varient_Name | Collection | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2022-23 | 2022-04-01 | Apr | Q1 | East | 2022-04-10 | NEFM02PFC | 1.0 | G | TF | SS | SS221 | SS221 | 112-SSL-ELGINROADKOLKATA | 2295 | 2295.0 | 2295.00 | Kolkata | WESTBENGAL | LFS | LFS | 2. 100 M Steele | Classic 100 ml | 2 |
| 1 | 2022-23 | 2022-04-01 | Apr | Q1 | East | 2022-04-15 | NEFW14PD1 | 1.0 | L | TF | SS | SS283 | SS283 | 188-SSL-ACROPOLISKOLKATA | 645 | 645.0 | 503.49 | Kolkata | WESTBENGAL | LFS | LFS | 7. 20 W Pristine | Classic 20 ml | 2 |
| 2 | 2022-23 | 2022-04-01 | Apr | Q1 | East | 2022-04-28 | NEFW11PD1 | 1.0 | L | TF | SS | SS283 | SS283 | 188-SSL-ACROPOLISKOLKATA | 645 | 645.0 | 645.00 | Kolkata | WESTBENGAL | LFS | LFS | 4. 20 W Celeste | Classic 20 ml | 2 |
| 3 | 2022-23 | 2022-04-01 | Apr | Q1 | North | 2022-04-01 | NEFW02PFC | 1.0 | L | TF | SS | SS216 | SS216 | 121-SSL-LUCKNOW | 2295 | 2295.0 | 2295.00 | Lucknow | UTTARPRADESH | LFS | LFS | 4. 100 W Celeste | Classic 100 ml | 2 |
| 4 | 2022-23 | 2022-04-01 | Apr | Q1 | North | 2022-04-02 | NFM01DQ1 | 1.0 | G | TF | SS | SS309 | SS309 | 478-SHOPPERSSTOP-TAPASYAONE | 499 | 499.0 | 499.00 | Gurgaon | HARYANA | LFS | LFS | 1. 150 M Raw Deo | Premium Deo | 2 |
| 5 | 2022-23 | 2022-04-01 | Apr | Q1 | North | 2022-04-03 | NEFP01PGFL | 1.0 | P | TF | SS | SS216 | SS216 | 121-SSL-LUCKNOW | 2695 | 2695.0 | 2695.00 | Lucknow | UTTARPRADESH | LFS | LFS | 1. His & Her 50 ml (R,C) | Gift Pack | 2 |
| 6 | 2022-23 | 2022-04-01 | Apr | Q1 | North | 2022-04-04 | FM01HQ2 | 1.0 | G | TF | SS | SS282 | SS282 | 267-SSL-JANAKPURI | 1845 | 1845.0 | 1845.00 | Delhi | DELHI | LFS | LFS | 10. Amalfi Coffret M EDP + Deo | Gift Pack | 2 |
| 7 | 2022-23 | 2022-04-01 | Apr | Q1 | South | 2022-04-05 | NEFP01PGFL | 1.0 | P | TF | SS | SS227 | SS227 | 154-SSL-CYBERABADINORBIT | 2695 | 2695.0 | 2695.00 | Hyderabad | TELANGANA | LFS | LFS | 1. His & Her 50 ml (R,C) | Gift Pack | 2 |
| 8 | 2022-23 | 2022-04-01 | Apr | Q1 | South | 2022-04-28 | NEFM01PGL | 1.0 | G | TF | SS | SS242 | SS242 | 161-SSL-MYSORE | 1595 | 1595.0 | 1595.00 | Mysore | KARNATAKA | LFS | LFS | 1. 50 M Raw | Classic 50 ml | 2 |
| 9 | 2022-23 | 2022-05-01 | May | Q1 | East | 2022-05-02 | FM21PC1 | 1.0 | G | TF | SS | SS303 | SS303 | 314-SSL-GUWAHATICITYCENTER | 3995 | 3995.0 | 3995.00 | Guwahati | WESTBENGAL | LFS | LFS | 1. Nox M 100 ml | Nox 100 ml | 2 |